package ebcs.database.mybatis.dao;

import ebcs.database.bean.BsGroupInfor;
import ebcs.database.bean.BsGroupInforExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface BsGroupInforMapper {
    int deleteByExample(BsGroupInforExample example);

    int insert(BsGroupInfor record);

    int insertSelective(BsGroupInfor record);

    List<BsGroupInfor> selectByExample(BsGroupInforExample example);

    int updateByExampleSelective(@Param("record") BsGroupInfor record, @Param("example") BsGroupInforExample example);

    int updateByExample(@Param("record") BsGroupInfor record, @Param("example") BsGroupInforExample example);
    List<BsGroupInfor> selectGroupDetail(BsGroupInfor group);
    List<BsGroupInfor> selectGroupDetailPage(BsGroupInfor group);
    int selectGroupDetailCount(BsGroupInfor group);
    List<BsGroupInfor> selectGroupByGroupName(@Param("groupName") String groupName);
    int updateGroupByGroupNo(BsGroupInfor group);
    int deleteGroupByGroupNo(@Param("proGroupNo") String proGroupNo);
    String selectGroupMaxRouId(); 
    
    //查询所有的团队经理openid及姓名
    List<BsGroupInfor> selectGroupOpenid(@Param("groupNo")String groupNo);
    //根据userinforRouid查询团队经理
    List<BsGroupInfor> selectGroupByUserRouid(String rouid);
    //根据项目组id查询团队经理的信息
    List<BsGroupInfor> selectGroupByProTeamNo(@Param("proTeamNo") String proTeamNo);
    
    List<BsGroupInfor> selectGroupByname(); 
  //根据userNo查询ProGroupNo yf 
    List<BsGroupInfor> selectProGroupNoByUserNo(String userNo);
}